<!DOCTYPE html>


<html lang="en">


<head>
  <meta charset="utf-8" />
    
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
  <title>
     Linson
  </title>
  <meta name="generator" content="hexo-theme-ayer">
  
  <link rel="shortcut icon" href="/blog/favicon.ico" />
  
  
<link rel="stylesheet" href="/blog/dist/main.css">

  
<link rel="stylesheet" href="https://cdn.jsdelivr.net/gh/Shen-Yu/cdn/css/remixicon.min.css">

  
<link rel="stylesheet" href="/blog/css/custom.css">

  
  
<script src="https://cdn.jsdelivr.net/npm/pace-js@1.0.2/pace.min.js"></script>

  
  

  

<link rel="alternate" href="/blog/atom.xml" title="Linson" type="application/atom+xml">
</head>

</html>

<body>
  
  <div id="app">
    <main class="content on">
      
<section class="cover">
    
  <div class="cover-frame">
    <div class="bg-box">
      <img src="images/cover3.jpg" alt="image frame" />
    </div>
    <div class="cover-inner text-center text-white">
      <h1><a href="/blog/">Linson</a></h1>
      <div id="subtitle-box">
        
        <span id="subtitle"></span>
        
      </div>
      <div>
        
      </div>
    </div>
  </div>
  <div class="cover-learn-more">
    <a href="javascript:void(0)" class="anchor"><i class="ri-arrow-down-line"></i></a>
  </div>
</section>



<script src="https://cdn.jsdelivr.net/npm/typed.js@2.0.11/lib/typed.min.js"></script>

<div id="main">
  <section class="outer">
  <article class="articles">
    
    
    
    
    <article id="post-docker_mysql镜像" class="article article-type-post" itemscope
  itemprop="blogPost" data-scroll-reveal>

  <div class="article-inner">
    
    <header class="article-header">
       
<h2 itemprop="name">
  <a class="article-title" href="/blog/2020/06/05/docker_mysql%E9%95%9C%E5%83%8F/"
    >docker_mysql镜像</a> 
</h2>
 

    </header>
    

    
    <div class="article-meta">
      <a href="/blog/2020/06/05/docker_mysql%E9%95%9C%E5%83%8F/" class="article-date">
  <time datetime="2020-06-05T09:22:20.000Z" itemprop="datePublished">2020-06-05</time>
</a>
      
  <div class="article-category">
    <a class="article-category-link" href="/blog/categories/%E6%8A%80%E6%9C%AF/">技术</a>
  </div>

      
    </div>
    

    

    
    <div class="article-entry" itemprop="articleBody">
      
      

      
      <h6 id="启动docker"><a href="#启动docker" class="headerlink" title="启动docker"></a>启动docker</h6><p>systemctl start docker</p>
<h6 id="拉取镜像"><a href="#拉取镜像" class="headerlink" title="拉取镜像"></a>拉取镜像</h6><ol>
<li>docker pull hub.c.163.com/library/mysql:5.7.17</li>
<li>docker pull docker.io/mysql:5.7.23</li>
<li>查看版本 <a href="https://hub.docker.com/_/mysql?tab=tags" target="_blank" rel="noopener">https://hub.docker.com/_/mysql?tab=tags</a></li>
</ol>
<h6 id="查看镜像"><a href="#查看镜像" class="headerlink" title="查看镜像"></a>查看镜像</h6><p>docker images | grep mysql</p>
<h6 id="使用镜像，后台运行（主机）"><a href="#使用镜像，后台运行（主机）" class="headerlink" title="使用镜像，后台运行（主机）"></a>使用镜像，后台运行（主机）</h6><figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br></pre></td><td class="code"><pre><span class="line">1. 创建 &#x2F;usr&#x2F;local&#x2F;java&#x2F;mysql&#x2F;mysql33063&#x2F;data 目录</span><br><span class="line">   mkdir -p &#x2F;usr&#x2F;local&#x2F;java&#x2F;mysql&#x2F;mysql33063&#x2F;data</span><br><span class="line">   &#x2F;&#x2F;如果不给data目录权限，启动会失败</span><br><span class="line">   chmod 777 &#x2F;usr&#x2F;local&#x2F;java&#x2F;mysql&#x2F;mysql33063&#x2F;data&#x2F;</span><br><span class="line">   mkdir -p &#x2F;usr&#x2F;local&#x2F;java&#x2F;mysql&#x2F;mysql33063&#x2F;logs</span><br><span class="line">   chmod 777 &#x2F;usr&#x2F;local&#x2F;java&#x2F;mysql&#x2F;mysql33063&#x2F;logs&#x2F;</span><br><span class="line">2. 创建 my.cnf 文件，添加配置信息</span><br><span class="line">   vi &#x2F;usr&#x2F;local&#x2F;java&#x2F;mysql&#x2F;mysql33063&#x2F;my.cnf</span><br></pre></td></tr></table></figure>

<blockquote>
<p>备份设置</p>
</blockquote>
<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br></pre></td><td class="code"><pre><span class="line">1. 创建 &#x2F;volume3&#x2F;存储空间3&#x2F;docker&#x2F;mysql&#x2F;mysql33063&#x2F;data 目录</span><br><span class="line">   mkdir -p &#x2F;volume3&#x2F;存储空间3&#x2F;docker&#x2F;mysql&#x2F;mysql33063&#x2F;data</span><br><span class="line">   &#x2F;&#x2F;如果不给data目录权限，启动会失败</span><br><span class="line">   chmod 777 &#x2F;volume3&#x2F;存储空间3&#x2F;docker&#x2F;mysql&#x2F;mysql33063&#x2F;data&#x2F;</span><br><span class="line">   mkdir -p &#x2F;volume3&#x2F;存储空间3&#x2F;docker&#x2F;mysql&#x2F;mysql33063&#x2F;logs</span><br><span class="line">   chmod 777 &#x2F;volume3&#x2F;存储空间3&#x2F;docker&#x2F;mysql&#x2F;mysql33063&#x2F;logs&#x2F;</span><br><span class="line">2. 创建 my.cnf 文件，添加配置信息</span><br><span class="line">   vi &#x2F;volume3&#x2F;存储空间3&#x2F;docker&#x2F;mysql&#x2F;mysql33063&#x2F;my.cnf</span><br></pre></td></tr></table></figure>
<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br><span class="line">16</span><br><span class="line">17</span><br></pre></td><td class="code"><pre><span class="line">[mysqld]</span><br><span class="line">pid-file        &#x3D; &#x2F;var&#x2F;run&#x2F;mysqld&#x2F;mysqld.pid</span><br><span class="line">socket          &#x3D; &#x2F;var&#x2F;run&#x2F;mysqld&#x2F;mysqld.sock</span><br><span class="line">datadir         &#x3D; &#x2F;var&#x2F;lib&#x2F;mysql</span><br><span class="line">server-id&#x3D;1</span><br><span class="line"># 表名不区分大小写 linux下默认是区分的，windows下默认不区分</span><br><span class="line">lower_case_table_names&#x3D;1</span><br><span class="line"># 主从配置</span><br><span class="line">log-bin&#x3D;mysql-bin</span><br><span class="line">log-error       &#x3D; &#x2F;logs&#x2F;error.log</span><br><span class="line">#bind-address   &#x3D; 127.0.0.1</span><br><span class="line">symbolic-links&#x3D;0</span><br><span class="line"># ---</span><br><span class="line">character-set-server&#x3D;utf8mb4</span><br><span class="line">[client]</span><br><span class="line">default-character-set&#x3D;utf8mb4</span><br><span class="line"># ---</span><br></pre></td></tr></table></figure>

<h6 id="后台启动容器并挂载配置文件"><a href="#后台启动容器并挂载配置文件" class="headerlink" title="后台启动容器并挂载配置文件"></a>后台启动容器并挂载配置文件</h6><ul>
<li>镜像中默认的配置文件是：/etc/mysql/my.cnf</li>
<li>镜像中数据目录是：/var/lib/mysql</li>
<li>挂载 my.cnf 到 /etc/mysql/conf.d/my.cnf 覆盖默认配置文件</li>
</ul>
<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br></pre></td><td class="code"><pre><span class="line">docker run -it --privileged&#x3D;true --name mysql33063 -p 33063:3306 \</span><br><span class="line">-v &#x2F;usr&#x2F;local&#x2F;java&#x2F;mysql&#x2F;mysql33063:&#x2F;etc&#x2F;mysql&#x2F;conf.d \</span><br><span class="line">-v &#x2F;usr&#x2F;local&#x2F;java&#x2F;mysql&#x2F;mysql33063&#x2F;data:&#x2F;var&#x2F;lib&#x2F;mysql \</span><br><span class="line">-v &#x2F;usr&#x2F;local&#x2F;java&#x2F;mysql&#x2F;mysql33063&#x2F;logs:&#x2F;logs \</span><br><span class="line">-e MYSQL_ROOT_PASSWORD&#x3D;123456 -d docker.io&#x2F;mysql:5.7.23</span><br><span class="line"></span><br><span class="line">&#x2F;&#x2F; --restart always 开机启动（未尝试）</span><br></pre></td></tr></table></figure>
<blockquote>
<p>备份设置</p>
</blockquote>
<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br></pre></td><td class="code"><pre><span class="line">docker run -it --privileged&#x3D;true --name mysql33063 -p 33063:3306 \</span><br><span class="line">-v &#x2F;volume3&#x2F;存储空间3&#x2F;docker&#x2F;mysql&#x2F;mysql33063:&#x2F;etc&#x2F;mysql&#x2F;conf.d \</span><br><span class="line">-v &#x2F;volume3&#x2F;存储空间3&#x2F;docker&#x2F;mysql&#x2F;mysql33063&#x2F;data:&#x2F;var&#x2F;lib&#x2F;mysql \</span><br><span class="line">-v &#x2F;volume3&#x2F;存储空间3&#x2F;docker&#x2F;mysql&#x2F;mysql33063&#x2F;logs:&#x2F;logs \</span><br><span class="line">-e MYSQL_ROOT_PASSWORD&#x3D;123456 -d docker.io&#x2F;mysql:5.7.23</span><br></pre></td></tr></table></figure>

<blockquote>
<p>注: -p 33063:3306 把服务器(docker宿主)的33063端口映射到mysql的3306端口</p>
</blockquote>
<h6 id="进入容器，登录mysql"><a href="#进入容器，登录mysql" class="headerlink" title="进入容器，登录mysql"></a>进入容器，登录mysql</h6><figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br></pre></td><td class="code"><pre><span class="line">docker ps</span><br><span class="line">docker exec -it 15a10ca101bf &#x2F;bin&#x2F;bash</span><br><span class="line">mysql -uroot -p</span><br></pre></td></tr></table></figure>

<h6 id="创建用户，并赋予远程登录权限-repl-user-123456"><a href="#创建用户，并赋予远程登录权限-repl-user-123456" class="headerlink" title="创建用户，并赋予远程登录权限 repl_user 123456"></a>创建用户，并赋予远程登录权限 repl_user 123456</h6><figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br></pre></td><td class="code"><pre><span class="line">grant all on *.* to repl_user@&#39;%&#39; identified by &quot;123456&quot;;</span><br><span class="line">update mysql.user set host &#x3D; &#39;%&#39; where user &#x3D; &#39;repl_user&#39;;</span><br><span class="line">flush privileges;</span><br><span class="line">select user, host from mysql.user;</span><br></pre></td></tr></table></figure>

<h6 id="远程登录"><a href="#远程登录" class="headerlink" title="远程登录"></a>远程登录</h6><figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">mysql -h192.168.3.132 -P33063 -uroot -p</span><br></pre></td></tr></table></figure>

<h6 id="其他"><a href="#其他" class="headerlink" title="其他"></a>其他</h6><ul>
<li>修改数据库字符集</li>
</ul>
<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">alter database test character set utf8mb4;</span><br></pre></td></tr></table></figure>

<ul>
<li>修改表字符集</li>
</ul>
<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">alter table t_user character set utf8mb4;</span><br></pre></td></tr></table></figure>
<ul>
<li>修改表中所有字段字符集<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">alter table t_user convert to character set utf8mb4 COLLATE utf8mb4_bin;</span><br></pre></td></tr></table></figure></li>
<li>修改表中单个字段字符集<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">alter table t_user modify username varchar(100) character set utf8mb4 collate utf8mb4_unicode_ci;</span><br></pre></td></tr></table></figure></li>
<li>查看日志<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">docker logs -f mysql33063</span><br></pre></td></tr></table></figure></li>
<li>备份数据（未测试）<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">docker exec mysql33063 sh -c &#39;exec mysqldump --all-databases -uroot -p&quot;123456&quot;&#39; &gt; &#x2F;some&#x2F;path&#x2F;on&#x2F;your&#x2F;host&#x2F;all-databases.sql</span><br></pre></td></tr></table></figure></li>
<li>恢复数据（未测试）<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">docker exec -i mysql33063 sh -c &#39;exec mysql -uroot -p&quot;123456&quot;&#39; &lt; &#x2F;some&#x2F;path&#x2F;on&#x2F;your&#x2F;host&#x2F;all-databases.sql</span><br></pre></td></tr></table></figure></li>
</ul>

      
      <!-- reward -->
      
    </div>
    
    
      <!-- copyright -->
      
    <footer class="article-footer">
      
      
  <ul class="article-tag-list" itemprop="keywords"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/blog/tags/docker/" rel="tag">docker</a></li><li class="article-tag-list-item"><a class="article-tag-list-link" href="/blog/tags/mysql/" rel="tag">mysql</a></li></ul>


    </footer>

  </div>

  

  
  
  

  
  
  

</article>
    
    <article id="post-typora和picgo" class="article article-type-post" itemscope
  itemprop="blogPost" data-scroll-reveal>

  <div class="article-inner">
    
    <header class="article-header">
       
<h2 itemprop="name">
  <a class="article-title" href="/blog/2020/06/05/typora%E5%92%8Cpicgo/"
    >typora和picgo</a> 
</h2>
 

    </header>
    

    
    <div class="article-meta">
      <a href="/blog/2020/06/05/typora%E5%92%8Cpicgo/" class="article-date">
  <time datetime="2020-06-05T01:20:42.193Z" itemprop="datePublished">2020-06-05</time>
</a>
      
      
    </div>
    

    

    
    <div class="article-entry" itemprop="articleBody">
      
      

      
      <h3 id="下载picgo安装"><a href="#下载picgo安装" class="headerlink" title="下载picgo安装"></a>下载picgo安装</h3><ol>
<li><a href="https://github.com/Molunerfinn/PicGo/releases" target="_blank" rel="noopener">https://github.com/Molunerfinn/PicGo/releases</a></li>
</ol>
<h3 id="搜索插件"><a href="#搜索插件" class="headerlink" title="搜索插件"></a>搜索插件</h3><p><img src="https://gitee.com/linson0116/learn_images/raw/master/image/image-20200601132631039.png" alt="image-20200601132631039"></p>
<h3 id="设置插件"><a href="#设置插件" class="headerlink" title="设置插件"></a>设置插件</h3><p><img src="https://gitee.com/linson0116/learn_images/raw/master/image/image-20200601133244049.png" alt="image-20200601133244049"></p>
<h3 id="设置-typora"><a href="#设置-typora" class="headerlink" title="设置 typora"></a>设置 typora</h3><p><img src="https://gitee.com/linson0116/learn_images/raw/master/image/image-20200601132919648.png" alt="image-20200601132919648"></p>

      
      <!-- reward -->
      
    </div>
    
    
      <!-- copyright -->
      
    <footer class="article-footer">
      
      

    </footer>

  </div>

  

  
  
  

  
  
  

</article>
    
    <article id="post-page5" class="article article-type-post" itemscope
  itemprop="blogPost" data-scroll-reveal>

  <div class="article-inner">
    
    <header class="article-header">
       
<h2 itemprop="name">
  <a class="article-title" href="/blog/2020/05/25/page5/"
    >page5</a> 
</h2>
 

    </header>
    

    
    <div class="article-meta">
      <a href="/blog/2020/05/25/page5/" class="article-date">
  <time datetime="2020-05-25T13:22:21.000Z" itemprop="datePublished">2020-05-25</time>
</a>
      
      
    </div>
    

    

    
    <div class="article-entry" itemprop="articleBody">
      
      

      
      <h3 id="标题"><a href="#标题" class="headerlink" title="标题"></a>标题</h3><ol>
<li>aaaa1122</li>
<li>bb</li>
</ol>
<h3 id="标题1"><a href="#标题1" class="headerlink" title="标题1"></a>标题1</h3><ol>
<li>sss</li>
<li>sss</li>
</ol>

      
      <!-- reward -->
      
    </div>
    
    
      <!-- copyright -->
      
    <footer class="article-footer">
      
      

    </footer>

  </div>

  

  
  
  

  
  
  

</article>
    
    <article id="post-测试" class="article article-type-post" itemscope
  itemprop="blogPost" data-scroll-reveal>

  <div class="article-inner">
    
    <header class="article-header">
       
<h2 itemprop="name">
  <a class="article-title" href="/blog/2020/05/25/%E6%B5%8B%E8%AF%95/"
    >测试</a> 
</h2>
 

    </header>
    

    
    <div class="article-meta">
      <a href="/blog/2020/05/25/%E6%B5%8B%E8%AF%95/" class="article-date">
  <time datetime="2020-05-25T13:22:21.000Z" itemprop="datePublished">2020-05-25</time>
</a>
      
      
    </div>
    

    

    
    <div class="article-entry" itemprop="articleBody">
      
      

      
      <h3 id="标题"><a href="#标题" class="headerlink" title="标题"></a>标题</h3><ol>
<li>aaaa1122</li>
<li>bb</li>
</ol>
<h3 id="标题1"><a href="#标题1" class="headerlink" title="标题1"></a>标题1</h3><ol>
<li>sss</li>
<li>sss</li>
</ol>

      
      <!-- reward -->
      
    </div>
    
    
      <!-- copyright -->
      
    <footer class="article-footer">
      
      

    </footer>

  </div>

  

  
  
  

  
  
  

</article>
    
    <article id="post-关于Ayer主题" class="article article-type-post" itemscope
  itemprop="blogPost" data-scroll-reveal>

  <div class="article-inner">
    
    <header class="article-header">
       
<h2 itemprop="name">
  <a class="article-title" href="/blog/2020/05/25/%E5%85%B3%E4%BA%8EAyer%E4%B8%BB%E9%A2%98/"
    >关于Ayer主题</a> 
</h2>
 

    </header>
    

    
    <div class="article-meta">
      <a href="/blog/2020/05/25/%E5%85%B3%E4%BA%8EAyer%E4%B8%BB%E9%A2%98/" class="article-date">
  <time datetime="2020-05-25T13:22:21.000Z" itemprop="datePublished">2020-05-25</time>
</a>
      
      
    </div>
    

    

    
    <div class="article-entry" itemprop="articleBody">
      
      

      
      <h3 id="主题"><a href="#主题" class="headerlink" title="主题"></a>主题</h3><ol>
<li>背景不能显示 search无法使用</li>
</ol>
<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br></pre></td><td class="code"><pre><span class="line"># 网站图标和侧边栏logo</span><br><span class="line">favicon: &#x2F;blog&#x2F;favicon.ico</span><br><span class="line">logo: &#x2F;blog&#x2F;images&#x2F;ayer-side.svg</span><br></pre></td></tr></table></figure>

<p>​    main.js</p>
<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br></pre></td><td class="code"><pre><span class="line">Z:\blog\themes\ayer\source\dist\main.js</span><br><span class="line">e.getScript(&quot;&#x2F;blog&#x2F;js&#x2F;search.js&quot;,function()&#123;searchFunc(&quot;&#x2F;blog&#x2F;search.xml&quot;,&quot;local-search-input&quot;,&quot;local-search-result&quot;)&#125;);</span><br></pre></td></tr></table></figure>

<p>​    /blog/ 使用绝对路径 解决图片显示和搜索的问题</p>
<ol start="2">
<li>发布命令</li>
</ol>
<figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br></pre></td><td class="code"><pre><span class="line">hexo clean &amp;&amp; hexo g &amp;&amp; hexo d</span><br></pre></td></tr></table></figure>

<p>​    在cmd下使用</p>
<ol start="3">
<li>每次更新需要在gitee下，服务中点击更新按钮</li>
</ol>

      
      <!-- reward -->
      
    </div>
    
    
      <!-- copyright -->
      
    <footer class="article-footer">
      
      

    </footer>

  </div>

  

  
  
  

  
  
  

</article>
    
    <article id="post-mysql主从同步配置文件" class="article article-type-post" itemscope
  itemprop="blogPost" data-scroll-reveal>

  <div class="article-inner">
    
    <header class="article-header">
       
<h2 itemprop="name">
  <a class="article-title" href="/blog/2020/05/25/mysql%E4%B8%BB%E4%BB%8E%E5%90%8C%E6%AD%A5%E9%85%8D%E7%BD%AE%E6%96%87%E4%BB%B6/"
    >mysql主从同步配置文件</a> 
</h2>
 

    </header>
    

    
    <div class="article-meta">
      <a href="/blog/2020/05/25/mysql%E4%B8%BB%E4%BB%8E%E5%90%8C%E6%AD%A5%E9%85%8D%E7%BD%AE%E6%96%87%E4%BB%B6/" class="article-date">
  <time datetime="2020-05-25T09:22:20.000Z" itemprop="datePublished">2020-05-25</time>
</a>
      
  <div class="article-category">
    <a class="article-category-link" href="/blog/categories/%E6%8A%80%E6%9C%AF/">技术</a>
  </div>

      
    </div>
    

    

    
    <div class="article-entry" itemprop="articleBody">
      
      

      
      <h4 id="mysql主从同步配置文件"><a href="#mysql主从同步配置文件" class="headerlink" title="mysql主从同步配置文件"></a>mysql主从同步配置文件</h4><figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br><span class="line">16</span><br><span class="line">17</span><br><span class="line">18</span><br><span class="line">19</span><br><span class="line">20</span><br><span class="line">21</span><br><span class="line">22</span><br><span class="line">23</span><br><span class="line">24</span><br><span class="line">25</span><br><span class="line">26</span><br><span class="line">27</span><br></pre></td><td class="code"><pre><span class="line">[mysqld]</span><br><span class="line">#--- mysql双主配置</span><br><span class="line"></span><br><span class="line"># skip_name_resolve&#x3D;ON</span><br><span class="line">#设置简单密码</span><br><span class="line"># validate_password_policy&#x3D;0</span><br><span class="line"># validate_password_length&#x3D;1</span><br><span class="line">###主配置</span><br><span class="line">log_bin&#x3D;bin_log</span><br><span class="line">##已配置</span><br><span class="line">#server-id&#x3D;1</span><br><span class="line"># 允许从复制的哪一个库</span><br><span class="line">binlog-do-db&#x3D;test</span><br><span class="line">#设置复制类型为 LOGICAL_CLOCK</span><br><span class="line">slave_parallel_type&#x3D;&#39;logical_clock&#39;</span><br><span class="line">#设置并行数量为 4</span><br><span class="line">slave_parallel_workers&#x3D;4</span><br><span class="line"></span><br><span class="line">###从配置</span><br><span class="line">relay-log&#x3D;relay-bin</span><br><span class="line">relay-log-index&#x3D;relay-bin.index</span><br><span class="line"># 允许复制主服务的库</span><br><span class="line">replicate-do-db&#x3D;test</span><br><span class="line"># 允许复制主服务的库的哪一张表</span><br><span class="line">replicate-do-table&#x3D;test.t_img</span><br><span class="line">replicate-do-table&#x3D;test.t_img_detail</span><br><span class="line">replicate-do-table&#x3D;test.t_sys_log</span><br></pre></td></tr></table></figure>


      
      <!-- reward -->
      
    </div>
    
    
      <!-- copyright -->
      
    <footer class="article-footer">
      
      
  <ul class="article-tag-list" itemprop="keywords"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/blog/tags/mysql/" rel="tag">mysql</a></li></ul>


    </footer>

  </div>

  

  
  
  

  
  
  

</article>
    
    <article id="post-page2" class="article article-type-post" itemscope
  itemprop="blogPost" data-scroll-reveal>

  <div class="article-inner">
    
    <header class="article-header">
       
<h2 itemprop="name">
  <a class="article-title" href="/blog/2020/05/25/page2/"
    >page2</a> 
</h2>
 

    </header>
    

    
    <div class="article-meta">
      <a href="/blog/2020/05/25/page2/" class="article-date">
  <time datetime="2020-05-25T09:22:20.000Z" itemprop="datePublished">2020-05-25</time>
</a>
      
  <div class="article-category">
    <a class="article-category-link" href="/blog/categories/%E6%8A%80%E6%9C%AF/">技术</a>
  </div>

      
    </div>
    

    

    
    <div class="article-entry" itemprop="articleBody">
      
      

      
      有东西被加密了, 请输入密码查看.
      
      <a class="article-more-link" href="/blog/2020/05/25/page2/">阅读更多...</a>
      
      
      <!-- reward -->
      
    </div>
    
    
      <!-- copyright -->
      
    <footer class="article-footer">
      
      
  <ul class="article-tag-list" itemprop="keywords"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/blog/tags/%E6%A0%87%E7%AD%BE2/" rel="tag">标签2</a></li></ul>


    </footer>

  </div>

  

  
  
  

  
  
  

</article>
    
    <article id="post-page3" class="article article-type-post" itemscope
  itemprop="blogPost" data-scroll-reveal>

  <div class="article-inner">
    
    <header class="article-header">
       
<h2 itemprop="name">
  <a class="article-title" href="/blog/2020/05/25/page3/"
    >page3</a> 
</h2>
 

    </header>
    

    
    <div class="article-meta">
      <a href="/blog/2020/05/25/page3/" class="article-date">
  <time datetime="2020-05-25T09:22:20.000Z" itemprop="datePublished">2020-05-25</time>
</a>
      
  <div class="article-category">
    <a class="article-category-link" href="/blog/categories/%E6%8A%80%E6%9C%AF/">技术</a>
  </div>

      
    </div>
    

    

    
    <div class="article-entry" itemprop="articleBody">
      
      

      
      有东西被加密了, 请输入密码查看.
      
      <a class="article-more-link" href="/blog/2020/05/25/page3/">阅读更多...</a>
      
      
      <!-- reward -->
      
    </div>
    
    
      <!-- copyright -->
      
    <footer class="article-footer">
      
      
  <ul class="article-tag-list" itemprop="keywords"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/blog/tags/s/" rel="tag">s</a></li></ul>


    </footer>

  </div>

  

  
  
  

  
  
  

</article>
    
    <article id="post-page4" class="article article-type-post" itemscope
  itemprop="blogPost" data-scroll-reveal>

  <div class="article-inner">
    
    <header class="article-header">
       
<h2 itemprop="name">
  <a class="article-title" href="/blog/2020/05/25/page4/"
    >page4</a> 
</h2>
 

    </header>
    

    
    <div class="article-meta">
      <a href="/blog/2020/05/25/page4/" class="article-date">
  <time datetime="2020-05-25T09:22:20.000Z" itemprop="datePublished">2020-05-25</time>
</a>
      
  <div class="article-category">
    <a class="article-category-link" href="/blog/categories/%E6%8A%80%E6%9C%AF/">技术</a>
  </div>

      
    </div>
    

    

    
    <div class="article-entry" itemprop="articleBody">
      
      

      
      有东西被加密了, 请输入密码查看.
      
      <a class="article-more-link" href="/blog/2020/05/25/page4/">阅读更多...</a>
      
      
      <!-- reward -->
      
    </div>
    
    
      <!-- copyright -->
      
    <footer class="article-footer">
      
      
  <ul class="article-tag-list" itemprop="keywords"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/blog/tags/%E6%A0%87%E7%AD%BE1/" rel="tag">标签1</a></li></ul>


    </footer>

  </div>

  

  
  
  

  
  
  

</article>
    
    <article id="post-mysql双主同步" class="article article-type-post" itemscope
  itemprop="blogPost" data-scroll-reveal>

  <div class="article-inner">
    
    <header class="article-header">
       
<h2 itemprop="name">
  <a class="article-title" href="/blog/2020/05/25/mysql%E5%8F%8C%E4%B8%BB%E5%90%8C%E6%AD%A5/"
    >mysql双主同步</a> 
</h2>
 

    </header>
    

    
    <div class="article-meta">
      <a href="/blog/2020/05/25/mysql%E5%8F%8C%E4%B8%BB%E5%90%8C%E6%AD%A5/" class="article-date">
  <time datetime="2020-05-25T09:22:20.000Z" itemprop="datePublished">2020-05-25</time>
</a>
      
  <div class="article-category">
    <a class="article-category-link" href="/blog/categories/%E6%8A%80%E6%9C%AF/">技术</a>
  </div>

      
    </div>
    

    

    
    <div class="article-entry" itemprop="articleBody">
      
      

      
      有东西被加密了, 请输入密码查看.
      
      <a class="article-more-link" href="/blog/2020/05/25/mysql%E5%8F%8C%E4%B8%BB%E5%90%8C%E6%AD%A5/">阅读更多...</a>
      
      
      <!-- reward -->
      
    </div>
    
    
      <!-- copyright -->
      
    <footer class="article-footer">
      
      
  <ul class="article-tag-list" itemprop="keywords"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/blog/tags/mysql/" rel="tag">mysql</a></li><li class="article-tag-list-item"><a class="article-tag-list-link" href="/blog/tags/s/" rel="tag">s</a></li></ul>


    </footer>

  </div>

  

  
  
  

  
  
  

</article>
    
  </article>
  

  
  <nav class="page-nav">
    
    <span class="page-number current">1</span><a class="page-number" href="/blog/page/2/">2</a><a class="extend next" rel="next" href="/blog/page/2/">下一页</a>
  </nav>
  
</section>
</div>

      <footer class="footer">
  <div class="outer">
    <ul>
      <li>
        Copyrights &copy;
        2019-2020
        <i class="ri-heart-fill heart_icon"></i> linson
      </li>
    </ul>
    <ul>
      <li>
        
      </li>
    </ul>
    <ul>
      <li>
        
        
        <span>
  <span><i class="ri-user-3-fill"></i>Visitors:<span id="busuanzi_value_site_uv"></span></s>
  <span class="division">|</span>
  <span><i class="ri-eye-fill"></i>Views:<span id="busuanzi_value_page_pv"></span></span>
</span>
        
      </li>
    </ul>
    <ul>
      
    </ul>
    <ul>
      <li>
        <!-- cnzz统计 -->
        
        <script type="text/javascript" src='https://s9.cnzz.com/z_stat.php?id=1278069914&amp;web_id=1278069914'></script>
        
      </li>
    </ul>
  </div>
</footer>
      <div class="float_btns">
        <div class="totop" id="totop">
  <i class="ri-arrow-up-line"></i>
</div>

<div class="todark" id="todark">
  <i class="ri-moon-line"></i>
</div>

      </div>
    </main>
    <aside class="sidebar on">
      <button class="navbar-toggle"></button>
<nav class="navbar">
  
  <div class="logo">
    <a href="/blog/"><img src="/blog/images/ayer-side.svg" alt="Linson"></a>
  </div>
  
  <ul class="nav nav-main">
    
    <li class="nav-item">
      <a class="nav-item-link" href="/blog/">主页</a>
    </li>
    
    <li class="nav-item">
      <a class="nav-item-link" href="/blog/archives">归档</a>
    </li>
    
    <li class="nav-item">
      <a class="nav-item-link" href="/blog/categories">分类</a>
    </li>
    
    <li class="nav-item">
      <a class="nav-item-link" href="/blog/photos">图片</a>
    </li>
    
    <li class="nav-item">
      <a class="nav-item-link" href="/blog/tags">标签</a>
    </li>
    
    <li class="nav-item">
      <a class="nav-item-link" href="/blog/about">关于我</a>
    </li>
    
  </ul>
</nav>
<nav class="navbar navbar-bottom">
  <ul class="nav">
    <li class="nav-item">
      
      <a class="nav-item-link nav-item-search"  title="Search">
        <i class="ri-search-line"></i>
      </a>
      
      
      <a class="nav-item-link" target="_blank" href="/blog/atom.xml" title="RSS Feed">
        <i class="ri-rss-line"></i>
      </a>
      
    </li>
  </ul>
</nav>
<div class="search-form-wrap">
  <div class="local-search local-search-plugin">
  <input type="search" id="local-search-input" class="local-search-input" placeholder="Search...">
  <div id="local-search-result" class="local-search-result"></div>
</div>
</div>
    </aside>
    <script>
      if (window.matchMedia("(max-width: 768px)").matches) {
        document.querySelector('.content').classList.remove('on');
        document.querySelector('.sidebar').classList.remove('on');
      }
    </script>
    <div id="mask"></div>

<!-- #reward -->
<div id="reward">
  <span class="close"><i class="ri-close-line"></i></span>
  <p class="reward-p"><i class="ri-cup-line"></i>请我喝杯咖啡吧~</p>
  <div class="reward-box">
    
    <div class="reward-item">
      <img class="reward-img" src="https://cdn.jsdelivr.net/gh/Shen-Yu/cdn/img/alipay.jpg">
      <span class="reward-type">支付宝</span>
    </div>
    
    
    <div class="reward-item">
      <img class="reward-img" src="https://cdn.jsdelivr.net/gh/Shen-Yu/cdn/img/wechat.jpg">
      <span class="reward-type">微信</span>
    </div>
    
  </div>
</div>
    
<script src="/blog/js/jquery-2.0.3.min.js"></script>


<script src="/blog/js/lazyload.min.js"></script>

<!-- Subtitle -->

<script>
  try {
    var typed = new Typed("#subtitle", {
      strings: ['面朝大海，春暖花开', '', '想要的都拥有，得不到的都释怀'],
      startDelay: 0,
      typeSpeed: 200,
      loop: true,
      backSpeed: 100,
      showCursor: true
    });
  } catch (err) {
    console.log(err)
  }
</script>

<!-- Tocbot -->

<script src="https://cdn.jsdelivr.net/npm/jquery-modal@0.9.2/jquery.modal.min.js"></script>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/jquery-modal@0.9.2/jquery.modal.min.css">
<script src="https://cdn.jsdelivr.net/npm/justifiedGallery@3.7.0/dist/js/jquery.justifiedGallery.min.js"></script>

<script src="/blog/dist/main.js"></script>

<!-- ImageViewer -->

<!-- Root element of PhotoSwipe. Must have class pswp. -->
<div class="pswp" tabindex="-1" role="dialog" aria-hidden="true">

    <!-- Background of PhotoSwipe. 
         It's a separate element as animating opacity is faster than rgba(). -->
    <div class="pswp__bg"></div>

    <!-- Slides wrapper with overflow:hidden. -->
    <div class="pswp__scroll-wrap">

        <!-- Container that holds slides. 
            PhotoSwipe keeps only 3 of them in the DOM to save memory.
            Don't modify these 3 pswp__item elements, data is added later on. -->
        <div class="pswp__container">
            <div class="pswp__item"></div>
            <div class="pswp__item"></div>
            <div class="pswp__item"></div>
        </div>

        <!-- Default (PhotoSwipeUI_Default) interface on top of sliding area. Can be changed. -->
        <div class="pswp__ui pswp__ui--hidden">

            <div class="pswp__top-bar">

                <!--  Controls are self-explanatory. Order can be changed. -->

                <div class="pswp__counter"></div>

                <button class="pswp__button pswp__button--close" title="Close (Esc)"></button>

                <button class="pswp__button pswp__button--share" style="display:none" title="Share"></button>

                <button class="pswp__button pswp__button--fs" title="Toggle fullscreen"></button>

                <button class="pswp__button pswp__button--zoom" title="Zoom in/out"></button>

                <!-- Preloader demo http://codepen.io/dimsemenov/pen/yyBWoR -->
                <!-- element will get class pswp__preloader--active when preloader is running -->
                <div class="pswp__preloader">
                    <div class="pswp__preloader__icn">
                        <div class="pswp__preloader__cut">
                            <div class="pswp__preloader__donut"></div>
                        </div>
                    </div>
                </div>
            </div>

            <div class="pswp__share-modal pswp__share-modal--hidden pswp__single-tap">
                <div class="pswp__share-tooltip"></div>
            </div>

            <button class="pswp__button pswp__button--arrow--left" title="Previous (arrow left)">
            </button>

            <button class="pswp__button pswp__button--arrow--right" title="Next (arrow right)">
            </button>

            <div class="pswp__caption">
                <div class="pswp__caption__center"></div>
            </div>

        </div>

    </div>

</div>

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/photoswipe@4.1.3/dist/photoswipe.min.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/photoswipe@4.1.3/dist/default-skin/default-skin.min.css">
<script src="https://cdn.jsdelivr.net/npm/photoswipe@4.1.3/dist/photoswipe.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/photoswipe@4.1.3/dist/photoswipe-ui-default.min.js"></script>

<script>
    function viewer_init() {
        let pswpElement = document.querySelectorAll('.pswp')[0];
        let $imgArr = document.querySelectorAll(('.article-entry img:not(.reward-img)'))

        $imgArr.forEach(($em, i) => {
            $em.onclick = () => {
                // slider展开状态
                // todo: 这样不好，后面改成状态
                if (document.querySelector('.left-col.show')) return
                let items = []
                $imgArr.forEach(($em2, i2) => {
                    let img = $em2.getAttribute('data-idx', i2)
                    let src = $em2.getAttribute('data-target') || $em2.getAttribute('src')
                    let title = $em2.getAttribute('alt')
                    // 获得原图尺寸
                    const image = new Image()
                    image.src = src
                    items.push({
                        src: src,
                        w: image.width || $em2.width,
                        h: image.height || $em2.height,
                        title: title
                    })
                })
                var gallery = new PhotoSwipe(pswpElement, PhotoSwipeUI_Default, items, {
                    index: parseInt(i)
                });
                gallery.init()
            }
        })
    }
    viewer_init()
</script>

<!-- MathJax -->

<!-- Katex -->

<!-- busuanzi  -->


<script src="/blog/js/busuanzi-2.3.pure.min.js"></script>


<!-- ClickLove -->

<!-- ClickBoom -->

<!-- CodeCopy -->


<link rel="stylesheet" href="/blog/css/clipboard.css">

<script src="https://cdn.jsdelivr.net/npm/clipboard@2/dist/clipboard.min.js"></script>
<script>
  function wait(callback, seconds) {
    var timelag = null;
    timelag = window.setTimeout(callback, seconds);
  }
  !function (e, t, a) {
    var initCopyCode = function(){
      var copyHtml = '';
      copyHtml += '<button class="btn-copy" data-clipboard-snippet="">';
      copyHtml += '<i class="ri-file-copy-2-line"></i><span>COPY</span>';
      copyHtml += '</button>';
      $(".highlight .code pre").before(copyHtml);
      $(".article pre code").before(copyHtml);
      var clipboard = new ClipboardJS('.btn-copy', {
        target: function(trigger) {
          return trigger.nextElementSibling;
        }
      });
      clipboard.on('success', function(e) {
        let $btn = $(e.trigger);
        $btn.addClass('copied');
        let $icon = $($btn.find('i'));
        $icon.removeClass('ri-file-copy-2-line');
        $icon.addClass('ri-checkbox-circle-line');
        let $span = $($btn.find('span'));
        $span[0].innerText = 'COPIED';
        
        wait(function () { // 等待两秒钟后恢复
          $icon.removeClass('ri-checkbox-circle-line');
          $icon.addClass('ri-file-copy-2-line');
          $span[0].innerText = 'COPY';
        }, 2000);
      });
      clipboard.on('error', function(e) {
        e.clearSelection();
        let $btn = $(e.trigger);
        $btn.addClass('copy-failed');
        let $icon = $($btn.find('i'));
        $icon.removeClass('ri-file-copy-2-line');
        $icon.addClass('ri-time-line');
        let $span = $($btn.find('span'));
        $span[0].innerText = 'COPY FAILED';
        
        wait(function () { // 等待两秒钟后恢复
          $icon.removeClass('ri-time-line');
          $icon.addClass('ri-file-copy-2-line');
          $span[0].innerText = 'COPY';
        }, 2000);
      });
    }
    initCopyCode();
  }(window, document);
</script>



    
  </div>
</body>

</html>